![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
16-bit ApplicationsAlthough 16-bit applications will run on Windows NT, they lack the efficiency and robustness of 32-bit native applications. If possible, migrate your applications to 32-bit NT applications rather than using 16-bit Windows or DOS applications. Newer 32-bit applications are portable between Windows NT and Windows 95. I/O PerformanceI/O performance is not usually an issue for the client machine. The typical application is loaded into memory and does not use the I/O subsystem unless swapping is occurring. If your machine is swapping, performance is severely degraded and faster I/O will not significantly help.
Microsoft Windows 3.1 and Windows for Workgroups 3.11Microsoft Windows 3.1 and Windows for Workgroups 3.11 have been in production for quite some time. Microsoft Windows is currently the most popular graphical operating environment. Although Microsoft Windows is a very good operating system for home use, I recommend that you use Windows for Workgroups if you are running in a networked environment. Windows for Workgroups provides better networking than Microsoft Windows. Windows for Workgroups also provides better 32-bit support than Microsoft Windows 3.1. MemoryAs with Windows NT, the major concern with the Windows or Windows for Workgroups client is the lack of memory. Because Windows and Windows for Workgroups are both virtual-memory systems, it is possible to run much larger applications than will fit in memory. Although this is possible, it causes swapping, which degrades performance. Unlike Windows NT and Windows 95, the Windows and Windows for Workgroups operating systems do not come with a performance monitoring tool that shows you when you have run out of memory. One way you can determine your memory usage under Windows 3.1 or Windows for Workgroups is to invoke a DOS shell and run the MEM command. The MEM command shows how much of your memory is currently in use. NetworkAnother way to reduce excess memory usage is to reduce the number of network protocols currently loaded. Only load those protocols you plan to use. By reducing the number of excess protocols, you reduce the need for memory and CPU usage.
Microsoft Windows 95The recently introduced Microsoft Windows 95 greatly improves the Windows operating system. Windows 95 includes integrated 32-bit support, built-in networking, and other optimizations. If you currently run on Windows 3.1 or Windows for Workgroups, seriously think about upgrading to Windows 95 or Windows NT. Windows 95 is robust and performs well but, like Windows NT, has an appetite for memory. Unless you have 12M or 16M of RAM, do not consider Windows 95. If you have the resources, there are many great features of Windows 95 that can help you optimize your system as an Oracle client:
The system monitor and integrated network subsystem features can substantially improve your optimization efforts. However, you must have enough system memory to run Windows 95. 32-Bit SupportWindows 95 is a 32-bit operating system that can run 16-bit applications. Even though it is possible to run 16-bit applications, doing so is not recommended. To take full advantage of Windows 95, you should run only 32-bit applications. Oracle provides 32-bit support for Windows 95 that has been optimized for the operating environment. By taking advantage of the 32-bit support feature, you can improve performance. MemoryWith Windows 95 as with every OS, you must reduce unnecessary memory usage so that you can allocate as many resources as possible to the application. By reducing or removing any nonessential overhead from the system, you can increase the amount of memory available for the application. You must ensure that you have sufficient memory to run your applications effectively. NetworkBy removing any unnecessary network clients, protocols, and services from the system, you reduce overhead. Running unnecessary network functions can increase CPU and memory overhead. With the Windows 95 network configuration utility, you can easily reduce these functions to the minimum required for your system. Oracle SupportOracle has recently provided native support for Windows 95. Use the Windows 95 version of SQL*Net to improve your applications performance. With native support for Windows 95, Oracle can take advantage of OS features and 32-bit support to optimize the product.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |